package dao;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import pojo.*;

import java.util.List;

/**
 * @author tao
 * @date 2021/11/11
 */
public interface TeaMenuDao {

    List<Clazz> selectAllClazz(int id);

    Clazz selectClazz(int id);

    int updateClazz(Clazz clazz);

    List<Student> selectAllStudent(int id);

    List<Work> selectAllWork(int id);

    int addClazz(Clazz clazz);

    int deleteClazz1(int id);

    int deleteClazz(int id);

    Student selectOneStudent(int id);

    int addStudent(ClazzAndStudent cs);

    int studentSize(int clazzID);

    int addWork(Work work);

    Work selectWork(int id);

    int updateWork(Work work);

    int[] selectClazzStudent(int clazzId);

    int addStuWork(@Param("sid") int sid,@Param("wid") int wid);

    int workBookId();

    //====级联删除=======
    int deleteStudentWork(int id);
    int deleteWork(int id);
    //==================

    List<MyWork> selectStudentWork(int wid);

    MyWork selectAStudentWork(int swid);

    int updateAStudentWork(@Param("swid") int swid,@Param("score")float score);


}
